package com.neusoft.tijiancms.mapper;

import com.neusoft.tijiancms.po.Setmeal;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SetmealMapper {

	/**
	 * 查询所有Setmeal列表
	 * @return
	 */
	@Select("select * from setmeal order by smId")
	public List<Setmeal> listSetmeal();

	/**
	 * 这是专门为OrdersMapper中的listOrders方法做关联查询用的
	 * @param smId
	 * @return
	 */
	@Select("select * from setmeal where smId=#{smId}")
	public Setmeal getSetmealByIdByMapper(Integer smId);

	/**
	 * 根据smId查询Setmeal对象
	 * @param smId
	 * @return
	 */
	public Setmeal getSetmealById(Integer smId);
}
